Profiling Report: v3_vista

Dataset statistics

Number of variables	23
Number of observations	87813
Missing cells	90411
Missing cells (%)	4.5%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	15.4 MiB
Average record size in memory	184.0 B

Variable types

Numeric	8
Categorical	15

Warnings

`tipo_persona` has constant value "Natural"	Constant
`sueldo_smdlv` is highly correlated with `otros_ingresos_smdlv` and 1 other fields	High correlation
`otros_ingresos_smdlv` is highly correlated with `sueldo_smdlv`	High correlation
`año_credito` is highly correlated with `sueldo_smdlv`	High correlation
`sueldo_smdlv` is highly correlated with `otros_ingresos_smdlv` and 1 other fields	High correlation
`otros_ingresos_smdlv` is highly correlated with `sueldo_smdlv`	High correlation
`año_credito` is highly correlated with `sueldo_smdlv`	High correlation
`valor_credito_smdlv` is highly correlated with `cuotas`	High correlation
`cuotas` is highly correlated with `valor_credito_smdlv`	High correlation
`municipio_residencia` is highly correlated with `municipio_credito` and 2 other fields	High correlation
`periodo_credito` is highly correlated with `Row` and 1 other fields	High correlation
`sueldo_smdlv` is highly correlated with `otros_ingresos_smdlv`	High correlation
`municipio_credito` is highly correlated with `municipio_residencia` and 2 other fields	High correlation
`municipio_expedicion` is highly correlated with `municipio_residencia` and 3 other fields	High correlation
`cuotas` is highly correlated with `forma_pago`	High correlation
`codeudor` is highly correlated with `Row`	High correlation
`genero` is highly correlated with `Row`	High correlation
`forma_pago` is highly correlated with `cuotas` and 3 other fields	High correlation
`año_credito` is highly correlated with `forma_pago`	High correlation
`Row` is highly correlated with `periodo_credito` and 5 other fields	High correlation
`otros_ingresos_smdlv` is highly correlated with `sueldo_smdlv`	High correlation
`municipio_nacimiento` is highly correlated with `municipio_residencia` and 3 other fields	High correlation
`estado_final` is highly correlated with `periodo_credito` and 1 other fields	High correlation
`municipio_expedicion` is highly correlated with `tipo_persona` and 1 other fields	High correlation
`sector` is highly correlated with `tipo_persona` and 1 other fields	High correlation
`tipo_persona` is highly correlated with `municipio_expedicion` and 13 other fields	High correlation
`procedencia` is highly correlated with `tipo_persona`	High correlation
`municipio_credito` is highly correlated with `tipo_persona` and 1 other fields	High correlation
`tipo_venta` is highly correlated with `tipo_persona`	High correlation
`municipio_residencia` is highly correlated with `tipo_persona` and 1 other fields	High correlation
`genero` is highly correlated with `tipo_persona`	High correlation
`forma_pago` is highly correlated with `sector` and 2 other fields	High correlation
`periodo_credito` is highly correlated with `tipo_persona`	High correlation
`estado_final` is highly correlated with `tipo_persona` and 1 other fields	High correlation
`tiene_casa_propia` is highly correlated with `tipo_persona`	High correlation
`municipio_nacimiento` is highly correlated with `municipio_expedicion` and 1 other fields	High correlation
`estado_civil` is highly correlated with `tipo_persona`	High correlation
`codeudor` is highly correlated with `tipo_persona`	High correlation
`sueldo_smdlv` has 8704 (9.9%) missing values	Missing
`otros_ingresos_smdlv` has 81706 (93.0%) missing values	Missing
`Row` has unique values	Unique

Reproduction

Analysis started	2021-05-12 19:50:48.491264
Analysis finished	2021-05-12 19:51:26.213323
Duration	37.72 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

Row
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	87813
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	68957.67679

Minimum	11674
Maximum	126896
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	686.2 KiB

Quantile statistics

Minimum	11674
5-th percentile	18527.6
Q1	40765
median	68886
Q3	97273
95-th percentile	120496.4
Maximum	126896
Range	115222
Interquartile range (IQR)	56508

Descriptive statistics

Standard deviation	32475.02055
Coefficient of variation (CV)	0.4709413377
Kurtosis	-1.166914784
Mean	68957.67679
Median Absolute Deviation (MAD)	28244
Skewness	0.0278328322
Sum	6055380472
Variance	1054626960
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20470	1	< 0.1%
105254	1	< 0.1%
17181	1	< 0.1%
23326	1	< 0.1%
21279	1	< 0.1%
109344	1	< 0.1%
113442	1	< 0.1%
111395	1	< 0.1%
101156	1	< 0.1%
99109	1	< 0.1%
Other values (87803)	87803	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
11674	1	< 0.1%
11675	1	< 0.1%
11677	1	< 0.1%
11678	1	< 0.1%
11680	1	< 0.1%
11682	1	< 0.1%
11684	1	< 0.1%
11686	1	< 0.1%
11690	1	< 0.1%
11701	1	< 0.1%

Value	Count	Frequency (%)
126896	1	< 0.1%
126895	1	< 0.1%
126894	1	< 0.1%
126893	1	< 0.1%
126887	1	< 0.1%
126883	1	< 0.1%
126882	1	< 0.1%
126880	1	< 0.1%
126878	1	< 0.1%
126877	1	< 0.1%

procedencia
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	686.2 KiB

Nacional	87594
Extranjero	219

Length

Max length	10
Median length	8
Mean length	8.004987872
Min length	8

Characters and Unicode

Total characters	702942
Distinct characters	13
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Nacional
2nd row	Extranjero
3rd row	Nacional
4th row	Nacional
5th row	Nacional

Common Values

Value	Count	Frequency (%)
Nacional	87594	99.8%
Extranjero	219	0.2%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
nacional	87594	99.8%
extranjero	219	0.2%

Most occurring characters

Value	Count	Frequency (%)
a	175407	25.0%
o	87813	12.5%
n	87813	12.5%
N	87594	12.5%
c	87594	12.5%
i	87594	12.5%
l	87594	12.5%
r	438	0.1%
E	219	< 0.1%
x	219	< 0.1%
Other values (3)	657	0.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	615129	87.5%
Uppercase Letter	87813	12.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	175407	28.5%
o	87813	14.3%
n	87813	14.3%
c	87594	14.2%
i	87594	14.2%
l	87594	14.2%
r	438	0.1%
x	219	< 0.1%
t	219	< 0.1%
j	219	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
N	87594	99.8%
E	219	0.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	702942	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	175407	25.0%
o	87813	12.5%
n	87813	12.5%
N	87594	12.5%
c	87594	12.5%
i	87594	12.5%
l	87594	12.5%
r	438	0.1%
E	219	< 0.1%
x	219	< 0.1%
Other values (3)	657	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	702942	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	175407	25.0%
o	87813	12.5%
n	87813	12.5%
N	87594	12.5%
c	87594	12.5%
i	87594	12.5%
l	87594	12.5%
r	438	0.1%
E	219	< 0.1%
x	219	< 0.1%
Other values (3)	657	0.1%

genero
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	686.2 KiB

Femenino	47760
Masculino	40053

Length

Max length	9
Median length	8
Mean length	8.456116976
Min length	8

Characters and Unicode

Total characters	742557
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Femenino
2nd row	Femenino
3rd row	Femenino
4th row	Femenino
5th row	Femenino

Common Values

Value	Count	Frequency (%)
Femenino	47760	54.4%
Masculino	40053	45.6%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
femenino	47760	54.4%
masculino	40053	45.6%

Most occurring characters

Value	Count	Frequency (%)
n	135573	18.3%
e	95520	12.9%
i	87813	11.8%
o	87813	11.8%
F	47760	6.4%
m	47760	6.4%
M	40053	5.4%
a	40053	5.4%
s	40053	5.4%
c	40053	5.4%
Other values (2)	80106	10.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	654744	88.2%
Uppercase Letter	87813	11.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	135573	20.7%
e	95520	14.6%
i	87813	13.4%
o	87813	13.4%
m	47760	7.3%
a	40053	6.1%
s	40053	6.1%
c	40053	6.1%
u	40053	6.1%
l	40053	6.1%

Uppercase Letter

Value	Count	Frequency (%)
F	47760	54.4%
M	40053	45.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	742557	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	135573	18.3%
e	95520	12.9%
i	87813	11.8%
o	87813	11.8%
F	47760	6.4%
m	47760	6.4%
M	40053	5.4%
a	40053	5.4%
s	40053	5.4%
c	40053	5.4%
Other values (2)	80106	10.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	742557	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	135573	18.3%
e	95520	12.9%
i	87813	11.8%
o	87813	11.8%
F	47760	6.4%
m	47760	6.4%
M	40053	5.4%
a	40053	5.4%
s	40053	5.4%
c	40053	5.4%
Other values (2)	80106	10.8%

estado_civil
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	686.2 KiB

Union Libre	33841
Casado	26868
Soltero	25684
Viudo	875
Divorciado	545

Length

Max length	11
Median length	7
Mean length	8.234225001
Min length	5

Characters and Unicode

Total characters	723072
Distinct characters	21
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Union Libre
2nd row	Soltero
3rd row	Soltero
4th row	Union Libre
5th row	Union Libre

Common Values

Value	Count	Frequency (%)
Union Libre	33841	38.5%
Casado	26868	30.6%
Soltero	25684	29.2%
Viudo	875	1.0%
Divorciado	545	0.6%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
union	33841	27.8%
libre	33841	27.8%
casado	26868	22.1%
soltero	25684	21.1%
viudo	875	0.7%
divorciado	545	0.4%

Most occurring characters

Value	Count	Frequency (%)
o	114042	15.8%
i	69647	9.6%
n	67682	9.4%
r	60070	8.3%
e	59525	8.2%
a	54281	7.5%
U	33841	4.7%
	33841	4.7%
L	33841	4.7%
b	33841	4.7%
Other values (11)	162461	22.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	567577	78.5%
Uppercase Letter	121654	16.8%
Space Separator	33841	4.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	114042	20.1%
i	69647	12.3%
n	67682	11.9%
r	60070	10.6%
e	59525	10.5%
a	54281	9.6%
b	33841	6.0%
d	28288	5.0%
s	26868	4.7%
l	25684	4.5%
Other values (4)	27649	4.9%

Uppercase Letter

Value	Count	Frequency (%)
U	33841	27.8%
L	33841	27.8%
C	26868	22.1%
S	25684	21.1%
V	875	0.7%
D	545	0.4%

Space Separator

Value	Count	Frequency (%)
	33841	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	689231	95.3%
Common	33841	4.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	114042	16.5%
i	69647	10.1%
n	67682	9.8%
r	60070	8.7%
e	59525	8.6%
a	54281	7.9%
U	33841	4.9%
L	33841	4.9%
b	33841	4.9%
d	28288	4.1%
Other values (10)	134173	19.5%

Common

Value	Count	Frequency (%)
	33841	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	723072	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	114042	15.8%
i	69647	9.6%
n	67682	9.4%
r	60070	8.3%
e	59525	8.2%
a	54281	7.5%
U	33841	4.7%
	33841	4.7%
L	33841	4.7%
b	33841	4.7%
Other values (11)	162461	22.5%

edad
Real number (ℝ_≥0)

Distinct	73
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	44.22053682

Minimum	18
Maximum	98
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	686.2 KiB

Quantile statistics

Minimum	18
5-th percentile	26
Q1	35
median	44
Q3	53
95-th percentile	65
Maximum	98
Range	80
Interquartile range (IQR)	18

Descriptive statistics

Standard deviation	11.91329055
Coefficient of variation (CV)	0.269406285
Kurtosis	-0.3882196952
Mean	44.22053682
Median Absolute Deviation (MAD)	9
Skewness	0.3303862305
Sum	3883138
Variance	141.9264916
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
44	3327	3.8%
40	3055	3.5%
45	2843	3.2%
41	2832	3.2%
49	2753	3.1%
35	2643	3.0%
46	2581	2.9%
42	2531	2.9%
39	2477	2.8%
31	2469	2.8%
Other values (63)	60302	68.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
18	7	< 0.1%
19	60	0.1%
20	198	0.2%
21	277	0.3%
22	421	0.5%
23	591	0.7%
24	696	0.8%
25	1043	1.2%
26	1312	1.5%
27	1475	1.7%

Value	Count	Frequency (%)
98	2	< 0.1%
90	3	< 0.1%
89	1	< 0.1%
88	2	< 0.1%
87	1	< 0.1%
85	6	< 0.1%
84	45	0.1%
83	50	0.1%
82	27	< 0.1%
81	41	< 0.1%

municipio_residencia
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	686.2 KiB

ARAUCA	37992
TAME	23392
Otros	13287
ARAUQUITA	9235
SARAVENA	3907

Length

Max length	9
Median length	6
Mean length	5.720405862
Min length	4

Characters and Unicode

Total characters	502326
Distinct characters	17
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ARAUQUITA
2nd row	ARAUCA
3rd row	ARAUCA
4th row	ARAUCA
5th row	ARAUCA

Common Values

Value	Count	Frequency (%)
ARAUCA	37992	43.3%
TAME	23392	26.6%
Otros	13287	15.1%
ARAUQUITA	9235	10.5%
SARAVENA	3907	4.4%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
arauca	37992	43.3%
tame	23392	26.6%
otros	13287	15.1%
arauquita	9235	10.5%
saravena	3907	4.4%

Most occurring characters

Value	Count	Frequency (%)
A	176794	35.2%
U	56462	11.2%
R	51134	10.2%
C	37992	7.6%
T	32627	6.5%
E	27299	5.4%
M	23392	4.7%
O	13287	2.6%
t	13287	2.6%
r	13287	2.6%
Other values (7)	56765	11.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	449178	89.4%
Lowercase Letter	53148	10.6%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	176794	39.4%
U	56462	12.6%
R	51134	11.4%
C	37992	8.5%
T	32627	7.3%
E	27299	6.1%
M	23392	5.2%
O	13287	3.0%
Q	9235	2.1%
I	9235	2.1%
Other values (3)	11721	2.6%

Lowercase Letter

Value	Count	Frequency (%)
t	13287	25.0%
r	13287	25.0%
o	13287	25.0%
s	13287	25.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	502326	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	176794	35.2%
U	56462	11.2%
R	51134	10.2%
C	37992	7.6%
T	32627	6.5%
E	27299	5.4%
M	23392	4.7%
O	13287	2.6%
t	13287	2.6%
r	13287	2.6%
Other values (7)	56765	11.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	502326	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	176794	35.2%
U	56462	11.2%
R	51134	10.2%
C	37992	7.6%
T	32627	6.5%
E	27299	5.4%
M	23392	4.7%
O	13287	2.6%
t	13287	2.6%
r	13287	2.6%
Other values (7)	56765	11.3%

municipio_nacimiento
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	686.2 KiB

Otros	33755
ARAUCA	28595
TAME	14455
ARAUQUITA	6424
SARAVENA	4584

Length

Max length	9
Median length	5
Mean length	5.61025133
Min length	4

Characters and Unicode

Total characters	492653
Distinct characters	17
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ARAUCA
2nd row	ARAUCA
3rd row	ARAUCA
4th row	ARAUCA
5th row	ARAUCA

Common Values

Value	Count	Frequency (%)
Otros	33755	38.4%
ARAUCA	28595	32.6%
TAME	14455	16.5%
ARAUQUITA	6424	7.3%
SARAVENA	4584	5.2%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
otros	33755	38.4%
arauca	28595	32.6%
tame	14455	16.5%
arauquita	6424	7.3%
saravena	4584	5.2%

Most occurring characters

Value	Count	Frequency (%)
A	133264	27.1%
U	41443	8.4%
R	39603	8.0%
O	33755	6.9%
t	33755	6.9%
r	33755	6.9%
o	33755	6.9%
s	33755	6.9%
C	28595	5.8%
T	20879	4.2%
Other values (7)	60094	12.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	357633	72.6%
Lowercase Letter	135020	27.4%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	133264	37.3%
U	41443	11.6%
R	39603	11.1%
O	33755	9.4%
C	28595	8.0%
T	20879	5.8%
E	19039	5.3%
M	14455	4.0%
Q	6424	1.8%
I	6424	1.8%
Other values (3)	13752	3.8%

Lowercase Letter

Value	Count	Frequency (%)
t	33755	25.0%
r	33755	25.0%
o	33755	25.0%
s	33755	25.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	492653	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	133264	27.1%
U	41443	8.4%
R	39603	8.0%
O	33755	6.9%
t	33755	6.9%
r	33755	6.9%
o	33755	6.9%
s	33755	6.9%
C	28595	5.8%
T	20879	4.2%
Other values (7)	60094	12.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	492653	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	133264	27.1%
U	41443	8.4%
R	39603	8.0%
O	33755	6.9%
t	33755	6.9%
r	33755	6.9%
o	33755	6.9%
s	33755	6.9%
C	28595	5.8%
T	20879	4.2%
Other values (7)	60094	12.2%

municipio_expedicion
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	686.2 KiB

ARAUCA	32964
Otros	31664
TAME	14385
ARAUQUITA	5411
SARAVENA	3389

Length

Max length	9
Median length	5
Mean length	5.573833032
Min length	4

Characters and Unicode

Total characters	489455
Distinct characters	17
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ARAUCA
2nd row	ARAUCA
3rd row	ARAUCA
4th row	ARAUCA
5th row	ARAUCA

Common Values

Value	Count	Frequency (%)
ARAUCA	32964	37.5%
Otros	31664	36.1%
TAME	14385	16.4%
ARAUQUITA	5411	6.2%
SARAVENA	3389	3.9%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
arauca	32964	37.5%
otros	31664	36.1%
tame	14385	16.4%
arauquita	5411	6.2%
saravena	3389	3.9%

Most occurring characters

Value	Count	Frequency (%)
A	139677	28.5%
U	43786	8.9%
R	41764	8.5%
C	32964	6.7%
O	31664	6.5%
t	31664	6.5%
r	31664	6.5%
o	31664	6.5%
s	31664	6.5%
T	19796	4.0%
Other values (7)	53148	10.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	362799	74.1%
Lowercase Letter	126656	25.9%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	139677	38.5%
U	43786	12.1%
R	41764	11.5%
C	32964	9.1%
O	31664	8.7%
T	19796	5.5%
E	17774	4.9%
M	14385	4.0%
Q	5411	1.5%
I	5411	1.5%
Other values (3)	10167	2.8%

Lowercase Letter

Value	Count	Frequency (%)
t	31664	25.0%
r	31664	25.0%
o	31664	25.0%
s	31664	25.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	489455	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	139677	28.5%
U	43786	8.9%
R	41764	8.5%
C	32964	6.7%
O	31664	6.5%
t	31664	6.5%
r	31664	6.5%
o	31664	6.5%
s	31664	6.5%
T	19796	4.0%
Other values (7)	53148	10.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	489455	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	139677	28.5%
U	43786	8.9%
R	41764	8.5%
C	32964	6.7%
O	31664	6.5%
t	31664	6.5%
r	31664	6.5%
o	31664	6.5%
s	31664	6.5%
T	19796	4.0%
Other values (7)	53148	10.9%

tipo_persona
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	686.2 KiB

Natural	87813

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	614691
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Natural
2nd row	Natural
3rd row	Natural
4th row	Natural
5th row	Natural

Common Values

Value	Count	Frequency (%)
Natural	87813	100.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
natural	87813	100.0%

Most occurring characters

Value	Count	Frequency (%)
a	175626	28.6%
N	87813	14.3%
t	87813	14.3%
u	87813	14.3%
r	87813	14.3%
l	87813	14.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	526878	85.7%
Uppercase Letter	87813	14.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	175626	33.3%
t	87813	16.7%
u	87813	16.7%
r	87813	16.7%
l	87813	16.7%

Uppercase Letter

Value	Count	Frequency (%)
N	87813	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	614691	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	175626	28.6%
N	87813	14.3%
t	87813	14.3%
u	87813	14.3%
r	87813	14.3%
l	87813	14.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	614691	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	175626	28.6%
N	87813	14.3%
t	87813	14.3%
u	87813	14.3%
r	87813	14.3%
l	87813	14.3%

tiene_casa_propia
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	686.2 KiB

Si	64886
No	22927

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	175626
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No
2nd row	No
3rd row	Si
4th row	No
5th row	No

Common Values

Value	Count	Frequency (%)
Si	64886	73.9%
No	22927	26.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
si	64886	73.9%
no	22927	26.1%

Most occurring characters

Value	Count	Frequency (%)
S	64886	36.9%
i	64886	36.9%
N	22927	13.1%
o	22927	13.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	87813	50.0%
Lowercase Letter	87813	50.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	64886	73.9%
N	22927	26.1%

Lowercase Letter

Value	Count	Frequency (%)
i	64886	73.9%
o	22927	26.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	175626	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	64886	36.9%
i	64886	36.9%
N	22927	13.1%
o	22927	13.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	175626	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
S	64886	36.9%
i	64886	36.9%
N	22927	13.1%
o	22927	13.1%

sueldo_smdlv
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	514
Distinct (%)	0.6%
Missing	8704
Missing (%)	9.9%
Infinite	0
Infinite (%)	0.0%
Mean	104.3314161

Minimum	3
Maximum	600
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	686.2 KiB

Quantile statistics

Minimum	3
5-th percentile	27
Q1	44
median	73
Q3	131
95-th percentile	290
Maximum	600
Range	597
Interquartile range (IQR)	87

Descriptive statistics

Standard deviation	90.01177771
Coefficient of variation (CV)	0.8627485472
Kurtosis	6.691830251
Mean	104.3314161
Median Absolute Deviation (MAD)	35
Skewness	2.269625533
Sum	8253554
Variance	8102.120126
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
34	1981	2.3%
36	1608	1.8%
43	1561	1.8%
61	1451	1.7%
72	1436	1.6%
68	1406	1.6%
30	1360	1.5%
76	1253	1.4%
46	1244	1.4%
65	1244	1.4%
Other values (504)	64565	73.5%
(Missing)	8704	9.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3	13	< 0.1%
4	3	< 0.1%
5	18	< 0.1%
6	28	< 0.1%
7	58	0.1%
8	24	< 0.1%
9	27	< 0.1%
10	146	0.2%
11	42	< 0.1%
12	37	< 0.1%

Value	Count	Frequency (%)
600	277	0.3%
599	2	< 0.1%
597	1	< 0.1%
594	1	< 0.1%
593	1	< 0.1%
588	49	0.1%
586	6	< 0.1%
584	6	< 0.1%
582	15	< 0.1%
576	12	< 0.1%

otros_ingresos_smdlv
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	219
Distinct (%)	3.6%
Missing	81706
Missing (%)	93.0%
Infinite	0
Infinite (%)	0.0%
Mean	54.82953987

Minimum	1
Maximum	300
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	686.2 KiB

Quantile statistics

Minimum	1
5-th percentile	8
Q1	20
median	36
Q3	68
95-th percentile	174
Maximum	300
Range	299
Interquartile range (IQR)	48

Descriptive statistics

Standard deviation	56.97399081
Coefficient of variation (CV)	1.039111234
Kurtosis	6.301325849
Mean	54.82953987
Median Absolute Deviation (MAD)	19
Skewness	2.399975784
Sum	334844
Variance	3246.035629
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
34	210	0.2%
36	186	0.2%
17	184	0.2%
18	174	0.2%
23	148	0.2%
20	145	0.2%
13	136	0.2%
21	136	0.2%
30	133	0.2%
26	120	0.1%
Other values (209)	4535	5.2%
(Missing)	81706	93.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	49	0.1%
4	29	< 0.1%
5	17	< 0.1%
6	74	0.1%
7	88	0.1%
8	51	0.1%
9	46	0.1%
10	112	0.1%

Value	Count	Frequency (%)
300	95	0.1%
294	8	< 0.1%
291	10	< 0.1%
289	1	< 0.1%
288	3	< 0.1%
279	2	< 0.1%
276	1	< 0.1%
271	5	< 0.1%
268	3	< 0.1%
264	2	< 0.1%

municipio_credito
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	686.2 KiB

ARAUCA	39350
TAME	23880
Otros	10369
ARAUQUITA	8765
SARAVENA	5449

Length

Max length	9
Median length	6
Mean length	5.761584276
Min length	4

Characters and Unicode

Total characters	505942
Distinct characters	17
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ARAUQUITA
2nd row	ARAUCA
3rd row	ARAUCA
4th row	ARAUCA
5th row	ARAUCA

Common Values

Value	Count	Frequency (%)
ARAUCA	39350	44.8%
TAME	23880	27.2%
Otros	10369	11.8%
ARAUQUITA	8765	10.0%
SARAVENA	5449	6.2%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
arauca	39350	44.8%
tame	23880	27.2%
otros	10369	11.8%
arauquita	8765	10.0%
saravena	5449	6.2%

Most occurring characters

Value	Count	Frequency (%)
A	184572	36.5%
U	56880	11.2%
R	53564	10.6%
C	39350	7.8%
T	32645	6.5%
E	29329	5.8%
M	23880	4.7%
O	10369	2.0%
t	10369	2.0%
r	10369	2.0%
Other values (7)	54615	10.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	464466	91.8%
Lowercase Letter	41476	8.2%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	184572	39.7%
U	56880	12.2%
R	53564	11.5%
C	39350	8.5%
T	32645	7.0%
E	29329	6.3%
M	23880	5.1%
O	10369	2.2%
Q	8765	1.9%
I	8765	1.9%
Other values (3)	16347	3.5%

Lowercase Letter

Value	Count	Frequency (%)
t	10369	25.0%
r	10369	25.0%
o	10369	25.0%
s	10369	25.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	505942	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	184572	36.5%
U	56880	11.2%
R	53564	10.6%
C	39350	7.8%
T	32645	6.5%
E	29329	5.8%
M	23880	4.7%
O	10369	2.0%
t	10369	2.0%
r	10369	2.0%
Other values (7)	54615	10.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	505942	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	184572	36.5%
U	56880	11.2%
R	53564	10.6%
C	39350	7.8%
T	32645	6.5%
E	29329	5.8%
M	23880	4.7%
O	10369	2.0%
t	10369	2.0%
r	10369	2.0%
Other values (7)	54615	10.8%

codeudor
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	686.2 KiB

SIN CODEUDOR	77099
CON CODEUDOR	10714

Length

Max length	12
Median length	12
Mean length	12
Min length	12

Characters and Unicode

Total characters	1053756
Distinct characters	10
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SIN CODEUDOR
2nd row	SIN CODEUDOR
3rd row	SIN CODEUDOR
4th row	SIN CODEUDOR
5th row	SIN CODEUDOR

Common Values

Value	Count	Frequency (%)
SIN CODEUDOR	77099	87.8%
CON CODEUDOR	10714	12.2%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
codeudor	87813	50.0%
sin	77099	43.9%
con	10714	6.1%

Most occurring characters

Value	Count	Frequency (%)
O	186340	17.7%
D	175626	16.7%
C	98527	9.4%
N	87813	8.3%
	87813	8.3%
E	87813	8.3%
U	87813	8.3%
R	87813	8.3%
S	77099	7.3%
I	77099	7.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	965943	91.7%
Space Separator	87813	8.3%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
O	186340	19.3%
D	175626	18.2%
C	98527	10.2%
N	87813	9.1%
E	87813	9.1%
U	87813	9.1%
R	87813	9.1%
S	77099	8.0%
I	77099	8.0%

Space Separator

Value	Count	Frequency (%)
	87813	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	965943	91.7%
Common	87813	8.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
O	186340	19.3%
D	175626	18.2%
C	98527	10.2%
N	87813	9.1%
E	87813	9.1%
U	87813	9.1%
R	87813	9.1%
S	77099	8.0%
I	77099	8.0%

Common

Value	Count	Frequency (%)
	87813	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1053756	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
O	186340	17.7%
D	175626	16.7%
C	98527	9.4%
N	87813	8.3%
	87813	8.3%
E	87813	8.3%
U	87813	8.3%
R	87813	8.3%
S	77099	7.3%
I	77099	7.3%

sector
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	686.2 KiB

PRIVADO	81059
PUBLICO	6753

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	614684
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	PRIVADO
2nd row	PRIVADO
3rd row	PRIVADO
4th row	PRIVADO
5th row	PRIVADO

Common Values

Value	Count	Frequency (%)
PRIVADO	81059	92.3%
PUBLICO	6753	7.7%
(Missing)	1	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
privado	81059	92.3%
publico	6753	7.7%

Most occurring characters

Value	Count	Frequency (%)
P	87812	14.3%
I	87812	14.3%
O	87812	14.3%
R	81059	13.2%
V	81059	13.2%
A	81059	13.2%
D	81059	13.2%
U	6753	1.1%
B	6753	1.1%
L	6753	1.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	614684	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
P	87812	14.3%
I	87812	14.3%
O	87812	14.3%
R	81059	13.2%
V	81059	13.2%
A	81059	13.2%
D	81059	13.2%
U	6753	1.1%
B	6753	1.1%
L	6753	1.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	614684	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
P	87812	14.3%
I	87812	14.3%
O	87812	14.3%
R	81059	13.2%
V	81059	13.2%
A	81059	13.2%
D	81059	13.2%
U	6753	1.1%
B	6753	1.1%
L	6753	1.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	614684	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
P	87812	14.3%
I	87812	14.3%
O	87812	14.3%
R	81059	13.2%
V	81059	13.2%
A	81059	13.2%
D	81059	13.2%
U	6753	1.1%
B	6753	1.1%
L	6753	1.1%

año_credito
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	26
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2014.531675

Minimum	1993
Maximum	2021
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	686.2 KiB

Quantile statistics

Minimum	1993
5-th percentile	2004
Q1	2012
median	2016
Q3	2019
95-th percentile	2020
Maximum	2021
Range	28
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	5.237870163
Coefficient of variation (CV)	0.002600043587
Kurtosis	0.5772577467
Mean	2014.531675
Median Absolute Deviation (MAD)	3
Skewness	-1.063953099
Sum	176902070
Variance	27.43528385
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=26)

Value	Count	Frequency (%)
2020	12328	14.0%
2019	11620	13.2%
2018	7294	8.3%
2015	6919	7.9%
2017	6327	7.2%
2016	5829	6.6%
2014	5380	6.1%
2013	4800	5.5%
2012	4329	4.9%
2011	3749	4.3%
Other values (16)	19238	21.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1993	1	< 0.1%
1997	202	0.2%
1998	399	0.5%
1999	505	0.6%
2000	587	0.7%
2001	856	1.0%
2002	855	1.0%
2003	833	0.9%
2004	1034	1.2%
2005	1442	1.6%

Value	Count	Frequency (%)
2021	1864	2.1%
2020	12328	14.0%
2019	11620	13.2%
2018	7294	8.3%
2017	6327	7.2%
2016	5829	6.6%
2015	6919	7.9%
2014	5380	6.1%
2013	4800	5.5%
2012	4329	4.9%

mes_credito
Real number (ℝ_≥0)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.840422261

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	686.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	7
Q3	10
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.482146677
Coefficient of variation (CV)	0.5090543455
Kurtosis	-1.218566074
Mean	6.840422261
Median Absolute Deviation (MAD)	3
Skewness	-0.1123632442
Sum	600678
Variance	12.12534548
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
12	9286	10.6%
10	8504	9.7%
11	7757	8.8%
9	7586	8.6%
7	7412	8.4%
6	7244	8.2%
5	7187	8.2%
8	6819	7.8%
3	6792	7.7%
2	6631	7.6%
Other values (2)	12595	14.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	6416	7.3%
2	6631	7.6%
3	6792	7.7%
4	6179	7.0%
5	7187	8.2%
6	7244	8.2%
7	7412	8.4%
8	6819	7.8%
9	7586	8.6%
10	8504	9.7%

Value	Count	Frequency (%)
12	9286	10.6%
11	7757	8.8%
10	8504	9.7%
9	7586	8.6%
8	6819	7.8%
7	7412	8.4%
6	7244	8.2%
5	7187	8.2%
4	6179	7.0%
3	6792	7.7%

valor_credito_smdlv
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	579
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	58.42896838

Minimum	0
Maximum	700
Zeros	785
Zeros (%)	0.9%
Negative	0
Negative (%)	0.0%
Memory size	686.2 KiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	16
median	40
Q3	71
95-th percentile	201
Maximum	700
Range	700
Interquartile range (IQR)	55

Descriptive statistics

Standard deviation	69.38218407
Coefficient of variation (CV)	1.187462076
Kurtosis	14.3136109
Mean	58.42896838
Median Absolute Deviation (MAD)	26
Skewness	3.09376473
Sum	5130823
Variance	4813.887466
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6	2955	3.4%
7	1947	2.2%
5	1842	2.1%
1	1751	2.0%
2	1671	1.9%
15	1390	1.6%
18	1282	1.5%
16	1247	1.4%
17	1237	1.4%
8	1233	1.4%
Other values (569)	71258	81.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	785	0.9%
1	1751	2.0%
2	1671	1.9%
3	1042	1.2%
4	1198	1.4%
5	1842	2.1%
6	2955	3.4%
7	1947	2.2%
8	1233	1.4%
9	969	1.1%

Value	Count	Frequency (%)
700	53	0.1%
697	1	< 0.1%
695	1	< 0.1%
691	1	< 0.1%
690	1	< 0.1%
687	1	< 0.1%
682	1	< 0.1%
677	1	< 0.1%
676	1	< 0.1%
675	1	< 0.1%

estado_final
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	686.2 KiB

PAGADO VENCIDO	38150
PAGADO ANTICIPADO	19882
CONTADO	17826
PAGADO A TIEMPO	5705
DESCUENTO EN VENTA	5231
Other values (3)	1019

Length

Max length	18
Median length	14
Mean length	13.54846093
Min length	7

Characters and Unicode

Total characters	1189731
Distinct characters	17
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CONTADO
2nd row	CONTADO
3rd row	CONTADO
4th row	CONTADO
5th row	CONTADO

Common Values

Value	Count	Frequency (%)
PAGADO VENCIDO	38150	43.4%
PAGADO ANTICIPADO	19882	22.6%
CONTADO	17826	20.3%
PAGADO A TIEMPO	5705	6.5%
DESCUENTO EN VENTA	5231	6.0%
DEVOLUCION	515	0.6%
CARTERA CASTIGADA	355	0.4%
OTROS CIERRES	149	0.2%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
pagado	63737	37.9%
vencido	38150	22.7%
anticipado	19882	11.8%
contado	17826	10.6%
a	5705	3.4%
tiempo	5705	3.4%
venta	5231	3.1%
descuento	5231	3.1%
en	5231	3.1%
devolucion	515	0.3%
Other values (4)	1008	0.6%

Most occurring characters

Value	Count	Frequency (%)
A	197775	16.6%
O	169685	14.3%
D	145696	12.2%
N	92066	7.7%
P	89324	7.5%
I	84638	7.1%
C	82463	6.9%
	80408	6.8%
E	65947	5.5%
G	64092	5.4%
Other values (7)	117637	9.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1109323	93.2%
Space Separator	80408	6.8%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	197775	17.8%
O	169685	15.3%
D	145696	13.1%
N	92066	8.3%
P	89324	8.1%
I	84638	7.6%
C	82463	7.4%
E	65947	5.9%
G	64092	5.8%
T	54734	4.9%
Other values (6)	62903	5.7%

Space Separator

Value	Count	Frequency (%)
	80408	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1109323	93.2%
Common	80408	6.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	197775	17.8%
O	169685	15.3%
D	145696	13.1%
N	92066	8.3%
P	89324	8.1%
I	84638	7.6%
C	82463	7.4%
E	65947	5.9%
G	64092	5.8%
T	54734	4.9%
Other values (6)	62903	5.7%

Common

Value	Count	Frequency (%)
	80408	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1189731	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	197775	16.6%
O	169685	14.3%
D	145696	12.2%
N	92066	7.7%
P	89324	7.5%
I	84638	7.1%
C	82463	6.9%
	80408	6.8%
E	65947	5.5%
G	64092	5.4%
Other values (7)	117637	9.9%

tipo_venta
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	686.2 KiB

ELECTRODOMESTICOS	87051
MOTOS	751
CONTRATO	11

Length

Max length	17
Median length	17
Mean length	16.89624543
Min length	5

Characters and Unicode

Total characters	1483710
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ELECTRODOMESTICOS
2nd row	ELECTRODOMESTICOS
3rd row	ELECTRODOMESTICOS
4th row	ELECTRODOMESTICOS
5th row	ELECTRODOMESTICOS

Common Values

Value	Count	Frequency (%)
ELECTRODOMESTICOS	87051	99.1%
MOTOS	751	0.9%
CONTRATO	11	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
electrodomesticos	87051	99.1%
motos	751	0.9%
contrato	11	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
O	262677	17.7%
E	261153	17.6%
T	174875	11.8%
S	174853	11.8%
C	174113	11.7%
M	87802	5.9%
R	87062	5.9%
L	87051	5.9%
D	87051	5.9%
I	87051	5.9%
Other values (2)	22	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1483710	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
O	262677	17.7%
E	261153	17.6%
T	174875	11.8%
S	174853	11.8%
C	174113	11.7%
M	87802	5.9%
R	87062	5.9%
L	87051	5.9%
D	87051	5.9%
I	87051	5.9%
Other values (2)	22	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1483710	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
O	262677	17.7%
E	261153	17.6%
T	174875	11.8%
S	174853	11.8%
C	174113	11.7%
M	87802	5.9%
R	87062	5.9%
L	87051	5.9%
D	87051	5.9%
I	87051	5.9%
Other values (2)	22	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1483710	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
O	262677	17.7%
E	261153	17.6%
T	174875	11.8%
S	174853	11.8%
C	174113	11.7%
M	87802	5.9%
R	87062	5.9%
L	87051	5.9%
D	87051	5.9%
I	87051	5.9%
Other values (2)	22	< 0.1%

periodo_credito
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	686.2 KiB

MENSUAL(ES)	71579
DIARIA(S)	15224
SEMANAL(ES)	766
QUINCENAL(ES)	244

Length

Max length	13
Median length	11
Mean length	10.65882045
Min length	9

Characters and Unicode

Total characters	935983
Distinct characters	14
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	DIARIA(S)
2nd row	DIARIA(S)
3rd row	DIARIA(S)
4th row	DIARIA(S)
5th row	DIARIA(S)

Common Values

Value	Count	Frequency (%)
MENSUAL(ES)	71579	81.5%
DIARIA(S)	15224	17.3%
SEMANAL(ES)	766	0.9%
QUINCENAL(ES)	244	0.3%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
mensual(es	71579	81.5%
diaria(s	15224	17.3%
semanal(es	766	0.9%
quincenal(es	244	0.3%

Most occurring characters

Value	Count	Frequency (%)
S	160158	17.1%
E	145178	15.5%
A	103803	11.1%
(	87813	9.4%
)	87813	9.4%
N	72833	7.8%
L	72589	7.8%
M	72345	7.7%
U	71823	7.7%
I	30692	3.3%
Other values (4)	30936	3.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	760357	81.2%
Open Punctuation	87813	9.4%
Close Punctuation	87813	9.4%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	160158	21.1%
E	145178	19.1%
A	103803	13.7%
N	72833	9.6%
L	72589	9.5%
M	72345	9.5%
U	71823	9.4%
I	30692	4.0%
D	15224	2.0%
R	15224	2.0%
Other values (2)	488	0.1%

Open Punctuation

Value	Count	Frequency (%)
(	87813	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	87813	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	760357	81.2%
Common	175626	18.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	160158	21.1%
E	145178	19.1%
A	103803	13.7%
N	72833	9.6%
L	72589	9.5%
M	72345	9.5%
U	71823	9.4%
I	30692	4.0%
D	15224	2.0%
R	15224	2.0%
Other values (2)	488	0.1%

Common

Value	Count	Frequency (%)
(	87813	50.0%
)	87813	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	935983	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
S	160158	17.1%
E	145178	15.5%
A	103803	11.1%
(	87813	9.4%
)	87813	9.4%
N	72833	7.8%
L	72589	7.8%
M	72345	7.7%
U	71823	7.7%
I	30692	3.3%
Other values (4)	30936	3.3%

cuotas
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	15
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.93397333

Minimum	0
Maximum	14
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	686.2 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	3
Q3	10
95-th percentile	14
Maximum	14
Range	14
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	4.563636673
Coefficient of variation (CV)	0.924941496
Kurtosis	-0.8753871904
Mean	4.93397333
Median Absolute Deviation (MAD)	2
Skewness	0.7763494299
Sum	433267
Variance	20.82677968
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
1	38167	43.5%
10	8802	10.0%
5	8462	9.6%
14	7699	8.8%
3	4127	4.7%
2	4078	4.6%
12	3777	4.3%
6	3605	4.1%
4	2860	3.3%
9	2333	2.7%
Other values (5)	3903	4.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	38167	43.5%
2	4078	4.6%
3	4127	4.7%
4	2860	3.3%
5	8462	9.6%
6	3605	4.1%
7	641	0.7%
8	1270	1.4%
9	2333	2.7%

Value	Count	Frequency (%)
14	7699	8.8%
13	254	0.3%
12	3777	4.3%
11	1737	2.0%
10	8802	10.0%
9	2333	2.7%
8	1270	1.4%
7	641	0.7%
6	3605	4.1%
5	8462	9.6%

forma_pago
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	686.2 KiB

CRÉDITO	67555
CONTADO	17826
LIBRANZA	2432

Length

Max length	8
Median length	7
Mean length	7.027695216
Min length	7

Characters and Unicode

Total characters	617123
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CONTADO
2nd row	CONTADO
3rd row	CONTADO
4th row	CONTADO
5th row	CONTADO

Common Values

Value	Count	Frequency (%)
CRÉDITO	67555	76.9%
CONTADO	17826	20.3%
LIBRANZA	2432	2.8%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
crédito	67555	76.9%
contado	17826	20.3%
libranza	2432	2.8%

Most occurring characters

Value	Count	Frequency (%)
O	103207	16.7%
C	85381	13.8%
T	85381	13.8%
D	85381	13.8%
R	69987	11.3%
I	69987	11.3%
É	67555	10.9%
A	22690	3.7%
N	20258	3.3%
L	2432	0.4%
Other values (2)	4864	0.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	617123	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
O	103207	16.7%
C	85381	13.8%
T	85381	13.8%
D	85381	13.8%
R	69987	11.3%
I	69987	11.3%
É	67555	10.9%
A	22690	3.7%
N	20258	3.3%
L	2432	0.4%
Other values (2)	4864	0.8%

Most occurring scripts

Value	Count	Frequency (%)
Latin	617123	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
O	103207	16.7%
C	85381	13.8%
T	85381	13.8%
D	85381	13.8%
R	69987	11.3%
I	69987	11.3%
É	67555	10.9%
A	22690	3.7%
N	20258	3.3%
L	2432	0.4%
Other values (2)	4864	0.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	549568	89.1%
Latin 1 Sup	67555	10.9%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
O	103207	18.8%
C	85381	15.5%
T	85381	15.5%
D	85381	15.5%
R	69987	12.7%
I	69987	12.7%
A	22690	4.1%
N	20258	3.7%
L	2432	0.4%
B	2432	0.4%

Latin 1 Sup

Value	Count	Frequency (%)
É	67555	100.0%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	Row	procedencia	genero	estado_civil	edad	municipio_residencia	municipio_nacimiento	municipio_expedicion	tipo_persona	tiene_casa_propia	sueldo_smdlv	otros_ingresos_smdlv	municipio_credito	codeudor	sector	año_credito	mes_credito	valor_credito_smdlv	estado_final	tipo_venta	periodo_credito	cuotas	forma_pago
0	11678	Nacional	Femenino	Union Libre	28	ARAUQUITA	ARAUCA	ARAUCA	Natural	No	68.0	NaN	ARAUQUITA	SIN CODEUDOR	PRIVADO	2020	6	78	CONTADO	ELECTRODOMESTICOS	DIARIA(S)	1	CONTADO
1	11710	Extranjero	Femenino	Soltero	31	ARAUCA	ARAUCA	ARAUCA	Natural	No	32.0	NaN	ARAUCA	SIN CODEUDOR	PRIVADO	2021	3	2	CONTADO	ELECTRODOMESTICOS	DIARIA(S)	1	CONTADO
2	11742	Nacional	Femenino	Soltero	46	ARAUCA	ARAUCA	ARAUCA	Natural	Si	47.0	NaN	ARAUCA	SIN CODEUDOR	PRIVADO	2020	11	5	CONTADO	ELECTRODOMESTICOS	DIARIA(S)	1	CONTADO
3	11774	Nacional	Femenino	Union Libre	24	ARAUCA	ARAUCA	ARAUCA	Natural	No	68.0	NaN	ARAUCA	SIN CODEUDOR	PRIVADO	2020	11	6	CONTADO	ELECTRODOMESTICOS	DIARIA(S)	1	CONTADO
4	11806	Nacional	Femenino	Union Libre	24	ARAUCA	ARAUCA	ARAUCA	Natural	No	273.0	30.0	ARAUCA	SIN CODEUDOR	PRIVADO	2020	6	6	CONTADO	ELECTRODOMESTICOS	DIARIA(S)	1	CONTADO
5	11838	Nacional	Femenino	Union Libre	26	TAME	ARAUCA	ARAUCA	Natural	No	36.0	NaN	TAME	SIN CODEUDOR	PRIVADO	2019	7	47	PAGADO VENCIDO	ELECTRODOMESTICOS	DIARIA(S)	14	CRÉDITO
6	11902	Nacional	Femenino	Casado	35	ARAUCA	ARAUCA	ARAUCA	Natural	Si	215.0	NaN	ARAUCA	SIN CODEUDOR	PRIVADO	2019	8	5	CONTADO	ELECTRODOMESTICOS	DIARIA(S)	1	CONTADO
7	11934	Nacional	Femenino	Casado	48	ARAUCA	ARAUCA	ARAUCA	Natural	No	NaN	NaN	ARAUCA	SIN CODEUDOR	PRIVADO	2020	6	270	CONTADO	ELECTRODOMESTICOS	DIARIA(S)	1	CONTADO
8	11966	Nacional	Femenino	Soltero	34	ARAUCA	ARAUCA	ARAUCA	Natural	No	102.0	34.0	ARAUCA	SIN CODEUDOR	PRIVADO	2020	12	6	CONTADO	ELECTRODOMESTICOS	DIARIA(S)	1	CONTADO
9	11998	Nacional	Femenino	Viudo	49	ARAUCA	ARAUCA	ARAUCA	Natural	Si	72.0	36.0	ARAUCA	SIN CODEUDOR	PRIVADO	2019	4	75	PAGADO VENCIDO	ELECTRODOMESTICOS	DIARIA(S)	14	CRÉDITO

Last rows

	Row	procedencia	genero	estado_civil	edad	municipio_residencia	municipio_nacimiento	municipio_expedicion	tipo_persona	tiene_casa_propia	sueldo_smdlv	otros_ingresos_smdlv	municipio_credito	codeudor	sector	año_credito	mes_credito	valor_credito_smdlv	estado_final	tipo_venta	periodo_credito	cuotas	forma_pago
87803	126761	Nacional	Masculino	Divorciado	46	TAME	TAME	TAME	Natural	Si	152.0	NaN	TAME	SIN CODEUDOR	PRIVADO	2013	3	47	PAGADO ANTICIPADO	ELECTRODOMESTICOS	DIARIA(S)	1	CRÉDITO
87804	126825	Nacional	Masculino	Union Libre	53	ARAUQUITA	ARAUQUITA	ARAUQUITA	Natural	Si	85.0	NaN	ARAUQUITA	SIN CODEUDOR	PRIVADO	2020	10	46	CONTADO	ELECTRODOMESTICOS	DIARIA(S)	1	CONTADO
87805	126527	Nacional	Masculino	Casado	42	Otros	Otros	Otros	Natural	Si	54.0	NaN	Otros	SIN CODEUDOR	PRIVADO	2019	9	36	CONTADO	ELECTRODOMESTICOS	DIARIA(S)	1	CONTADO
87806	126623	Nacional	Masculino	Union Libre	27	ARAUCA	ARAUQUITA	ARAUQUITA	Natural	No	68.0	NaN	ARAUCA	SIN CODEUDOR	PRIVADO	2020	9	83	CONTADO	ELECTRODOMESTICOS	DIARIA(S)	1	CONTADO
87807	126655	Nacional	Masculino	Union Libre	26	TAME	TAME	TAME	Natural	Si	6.0	NaN	TAME	SIN CODEUDOR	PRIVADO	2015	3	2	PAGADO ANTICIPADO	ELECTRODOMESTICOS	DIARIA(S)	1	CRÉDITO
87808	126687	Nacional	Masculino	Casado	28	ARAUQUITA	ARAUQUITA	ARAUQUITA	Natural	Si	31.0	NaN	ARAUQUITA	SIN CODEUDOR	PRIVADO	2020	9	1	CONTADO	ELECTRODOMESTICOS	DIARIA(S)	1	CONTADO
87809	126719	Nacional	Masculino	Soltero	42	ARAUCA	TAME	TAME	Natural	Si	262.0	NaN	ARAUCA	SIN CODEUDOR	PRIVADO	2010	7	66	CONTADO	ELECTRODOMESTICOS	DIARIA(S)	1	CONTADO
87810	126751	Nacional	Masculino	Union Libre	37	ARAUQUITA	ARAUQUITA	ARAUQUITA	Natural	Si	NaN	NaN	ARAUQUITA	SIN CODEUDOR	PRIVADO	2020	10	14	CONTADO	ELECTRODOMESTICOS	DIARIA(S)	1	CONTADO
87811	126783	Nacional	Masculino	Casado	60	ARAUQUITA	ARAUQUITA	ARAUQUITA	Natural	Si	36.0	NaN	ARAUQUITA	SIN CODEUDOR	PRIVADO	2019	9	5	CONTADO	ELECTRODOMESTICOS	DIARIA(S)	1	CONTADO
87812	126815	Nacional	Masculino	Union Libre	48	TAME	TAME	TAME	Natural	Si	97.0	NaN	TAME	SIN CODEUDOR	PRIVADO	2014	2	107	PAGADO VENCIDO	ELECTRODOMESTICOS	DIARIA(S)	14	CRÉDITO

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category